SELECT ident, naziv,IF( slika_1 IS NULL ,'/gfx/_box-images/ni_slike.jpg',slika_1) as slika_1,cena_pred_akcijo,cena FROM _produkti_aures
WHERE kategorija = 'Čelade Airoh'
ORDER BY cena LIMIT 18,9
AIROH VALOR WINGS YELLOW MATT
169,99 €
Airoh Valor Mad
169,99 €
Airoh Helios Mad
169,99 €
Airoh Helios UP RDEČA
169,99 €
Airoh Movement Strong
219,99 € 174,50 €
Airoh Movement First
191,80 € 174,50 €
Airoh Wraap IDOL ANTHRACITE MATT
175,99 €
Airoh Wraap IDOL ORANGE MATT
175,99 €
Airoh Wraap RAZE BLUE GLOSS
175,99 €